Supported Data Types
The following table shows the Google Cloud BigQuery data warehouse data types that are supported when using Qlik Compose and the default mapping from Qlik Compose data types.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using.
Compose Data Type |
BigQuery Data Type |
---|---|
BYTES |
BYTES |
DATE |
DATE |
TIME |
TIME |
DATETIME |
If scale <=6: TIMESTAMP If scale >6: STRING |
BIGINT |
INTEGER |
DECIMAL |
If the data can be stored in 38,9, then: NUMERIC If not, then: STRING with length of original precision +2 |
VARCHAR |
STRING |
INTEGER |
INTEGER |
Unsupported Data Types
The following Google Cloud BigQuery data types are not supported:
GEOGRAPHY, STRUCT, and ARRAY.